SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004816s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544212 LIMIT 1 [ RunTime:0.000440s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544212 [ RunTime:0.003110s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (188482,842231,684329,111380,983900,355382,89881,540749,714301,66733,245780,133649,308142,457725,121066,6466,557023,883293,985959,539555,598474,714996,73102,44343,831123,222235,756943,616446,438876,1035475,501503,309553,413066,390917,773129,665859,493829,865656,545050,302701,518761,761408,527687,663975,720045,722167,772690,707431,314218,1015120,1001798,166601,482962,814525,469455,439058,81864,604723,560274,117641) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]