SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 809183 LIMIT 1 [ RunTime:0.001512s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 809183 [ RunTime:0.001894s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (337085,949242,58181,405267,277306,561503,876919,951839,661280,810314,699796,115072,591060,729049,676939,219909,955913,425681,956273,197653,983073,709601,406495,247030,825279,869353,776658,104040,677721,117246,692440,134986,1028715,18016,688771,24297,851628,74636,735420,330018,508304,724758,841354,264071,292295,513795,107713,948581,713631,508838,473733,29601,827027,1027131,986639,983340,251081,876165,310258,500040) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004617s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 809183 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000524s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 809183 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]