SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 211148 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 211148 [ RunTime:0.001476s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (87292,824979,484352,501864,776533,206216,563404,45230,1031203,592236,206442,353894,1031822,58440,488153,497087,111238,523440,956822,609860,215453,319269,675230,313420,180966,986154,815451,400477,285222,235481,992333,272565,997460,376176,830399,181889,993774,670997,207754,961528,712007,743056,204497,990752,12403,465107,74318,292723,55593,833403,612680,302688,967448,138279,853344,975998,122591,278902,404511,147822) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 211148 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 211148 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]