SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001546s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 316091 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 316091 [ RunTime:0.002093s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (927989,27465,293043,537421,291142,801947,848758,908759,90608,29205,1027955,665580,1041111,953089,17582,823297,364694,454317,232994,458692,690489,732414,372281,919697,512175,513410,867872,962051,382655,561065,969756,107998,828163,407138,946851,895600,476531,409449,8959,411956,540536,575755,491857,246878,393860,273339,484517,480330,938467,392497,729032,745545,518093,155167,159976,243873,912139,389262,257860,690797) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 316091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 316091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000464s ]