SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 487903 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 487903 [ RunTime:0.003664s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (857237,400666,66604,179326,279350,236921,158707,110009,601805,568520,924074,381573,706985,551573,973351,966427,674556,647709,128698,801373,666658,1041346,185257,228636,391888,644829,56225,463878,166025,548084,542149,1029015,831882,537696,678618,935489,725213,602614,1025289,156940,593956,918382,405015,773431,215616,977318,569565,1015394,394595,265141,171093,41179,16095,417403,749487,35768,729903,484484,120943,798500) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 487903 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 487903 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]