SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 855610 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 855610 [ RunTime:0.001707s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (439572,323340,324220,470128,494477,548937,865681,188536,918568,852218,426414,368929,396689,664183,231715,56313,549258,376241,408190,1030820,719427,1029181,347101,315035,788204,527889,569661,91489,732236,82331,453159,297404,805121,650649,437722,423470,825455,469390,1047103,713818,254518,11899,804985,899901,54036,847269,675597,477529,955722,449277,41810,558603,604181,64916,751778,649814,743284,69085,732172,692370) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 855610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 855610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]