SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401103 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401103 [ RunTime:0.002076s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (863102,1007143,1035754,172116,558612,94796,91399,774421,787188,390110,468126,411726,276506,734400,399594,1012893,692355,975155,1047323,657675,138300,713599,591193,947724,237666,309320,325735,458800,514274,720441,140384,24847,527975,649262,969810,558813,543679,564300,28668,920108,265794,487692,313496,194122,235562,358659,69942,615149,478065,126295,161414,890533,511095,754478,953342,383248,980955,412327,389811,677823) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]