SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438187 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438187 [ RunTime:0.001663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (473201,464256,396539,357901,517789,221278,577961,718089,848134,801254,846677,873485,965885,127133,708300,829037,385026,217193,974661,387588,123899,892583,446069,400296,139696,79476,825704,616190,637266,380764,1015077,462819,145488,308839,801667,652402,588915,748102,894949,230743,271693,125349,221785,831365,34279,574763,947521,90627,354503,154569,336637,225315,800400,443644,350518,507806,408861,184481,594812,1029818) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438187 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438187 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002154s ]