SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 977312 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 977312 [ RunTime:0.001781s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (495941,669710,294935,171209,168972,753386,201196,479030,342614,159381,448750,879137,359875,487225,102076,966268,702835,548160,570096,763223,513639,71808,791977,721069,967591,620664,122999,952493,810060,54414,188956,181304,73739,112803,843319,322656,1026387,154812,897336,29490,219387,961384,954886,140752,65170,571749,460501,223012,557382,894161,887869,511678,865136,1041523,1031396,333613,891217,219043,862598,281468) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001748s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 977312 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 977312 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000648s ]