SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001606s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 983316 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 983316 [ RunTime:0.001826s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401009,139385,31146,675130,978890,323578,563072,204978,731477,986306,902815,988811,37176,1044532,87518,253131,759118,935259,618914,967054,509611,329244,84523,51235,838514,6006,573955,84346,276522,563225,39594,86271,468450,673118,401973,913821,539155,483059,650763,285641,147138,62746,668881,362111,534501,335776,656422,393380,649251,485860,241717,110138,1048178,573903,242615,409705,566022,291141,610302,1017291) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 983316 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002745s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 983316 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.007113s ]