SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200409 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200409 [ RunTime:0.001485s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (458411,910834,984434,728863,688553,457432,928854,49502,986679,870384,227484,889809,648469,1031356,900961,300867,640989,621707,626942,915542,415226,854136,697748,440585,211669,283853,656873,60849,589150,948178,638666,1036510,1009225,172542,243838,477449,1041019,867585,63245,516047,505444,857274,589011,666024,118845,210564,581093,443240,136903,302937,851921,322062,894560,1035945,504351,190532,123898,42958,181244,783851) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001598s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]