SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003749s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 29838 LIMIT 1 [ RunTime:0.001256s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 29838 [ RunTime:0.003246s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (898997,188158,1048497,944636,489621,902394,702407,152140,554448,876094,102036,139575,101770,568604,844303,97258,203236,763301,591978,549285,880052,184993,447431,339365,147327,620256,586924,215753,109630,353076,427531,688027,780532,580155,386528,658058,890035,379371,128640,830615,605919,224363,579258,137143,843111,1032525,117442,311396,238973,935509,304997,383085,275284,838590,603051,129656,266075,933159,500894,232075) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 29838 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 29838 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]