SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 683281 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 683281 [ RunTime:0.003023s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (481462,321117,456701,475360,154814,436516,715625,290537,1035600,477666,327678,1042332,781451,828945,367341,231008,862069,417943,138329,1000236,524759,79232,599581,599142,412409,458204,540746,983378,234580,834193,1004456,977660,1008149,521129,783666,431194,1047072,452769,434745,947699,445872,30807,155645,270815,394948,40131,735286,274565,1046604,914968,515453,159325,54628,668955,173090,335361,788761,200996,555927,649064) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 683281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 683281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]