SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 597907 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 597907 [ RunTime:0.006910s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (161219,622053,840805,659297,869488,1006997,951410,399853,221945,131285,1008659,117578,608965,497933,280250,234410,256735,9552,204395,273993,676322,106772,208,681058,203705,34298,546396,783922,330010,137278,875654,736420,684309,302749,910419,322206,754669,707268,101685,390864,396643,110686,24621,474713,245195,388916,744511,517940,388865,974061,782666,305934,149490,209115,294008,306610,687251,504215,892297,867845) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 597907 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000968s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 597907 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]