SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520947 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520947 [ RunTime:0.001591s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (447411,500704,1002309,348862,197402,384974,986318,488861,865445,510570,488172,373149,493144,321325,881894,861728,253235,942707,278857,234026,677569,488255,590440,133650,959411,736785,582668,1030910,995929,959963,454286,189876,119891,220076,735801,86182,998817,789247,732455,873224,970779,263873,527116,224403,723548,495117,64919,393823,717563,75756,972785,1047912,738937,575912,769256,770484,777221,436676,1031924,94570) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000946s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520947 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520947 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000418s ]