SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 380671 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 380671 [ RunTime:0.002325s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (4019,673567,840874,450966,624827,436425,574347,1010084,979700,1032775,428289,576409,652363,244173,494488,909513,126336,334755,247818,217479,948006,23363,68577,701181,985684,299598,751668,552007,1015137,972625,862137,124202,1005132,204321,185499,216550,48653,214938,464015,86237,544343,948540,1002311,1045454,1017333,744232,851700,410081,241018,453111,319059,295399,259357,521375,892402,164469,30643,450204,357569,966537) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 380671 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 380671 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000426s ]