SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40036 LIMIT 1 [ RunTime:0.000470s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40036 [ RunTime:0.002004s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (617616,629908,382608,112378,453094,50983,769275,453656,709287,1012820,856377,672260,283931,352321,702199,1032648,567952,183489,28688,116567,129197,348627,81409,341590,330054,319790,717338,499214,929248,127505,98517,788605,210083,383138,13099,279039,23573,819308,54584,401168,1012946,751081,418919,546440,117171,68463,983944,248790,732258,370733,736119,585407,968128,362323,620369,818926,604771,323683,1019947,638672) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40036 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40036 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]