SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001343s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010856 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010856 [ RunTime:0.001566s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (790222,331041,581262,150244,910213,375563,2615,314976,490103,762590,418942,88071,636851,287153,310016,12365,236167,488597,411679,396200,415966,837929,454102,302463,445525,880148,756066,577047,361354,834285,199236,941620,402628,916461,841049,393838,852869,621969,289344,948298,986087,579477,504885,495042,6405,909310,711657,434432,34076,50835,1029640,769104,1848,548543,192470,72024,991097,779434,666823,667035) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002253s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010856 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000652s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010856 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000803s ]