SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291521 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291521 [ RunTime:0.001628s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (280671,709559,112046,347991,207105,630663,202969,549807,1008601,726252,309680,344944,315078,844489,356105,511475,383280,231173,786045,845722,561020,126453,405983,547952,887947,396929,854055,730726,858345,45661,332150,194286,786741,706302,90616,605126,416835,258716,343934,138163,507659,178624,1000585,37399,623576,761858,465206,150288,258399,1030832,875028,341121,143570,284471,747886,193728,733398,652329,443816,572602) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291521 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291521 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000670s ]