SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011567 LIMIT 1 [ RunTime:0.000663s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011567 [ RunTime:0.001773s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (316982,44883,249245,962570,689894,594448,691071,301356,888422,156098,9848,245179,419542,800078,684536,343541,606076,276755,5210,710932,822085,482740,69550,675019,121781,827551,181017,1023229,241207,265331,293475,179617,501609,659521,406450,1033649,692759,464483,144533,79844,713276,252021,65347,111853,210239,140076,105919,486031,470156,856712,658701,339601,87842,9619,507612,284323,364417,901689,37966,907688) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011567 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000522s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011567 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]