SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 464522 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 464522 [ RunTime:0.001670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (377699,160515,273793,197547,533764,624046,5318,7241,150705,1032903,25827,177794,198013,184964,802097,124948,739258,124771,133939,514098,991928,455270,398667,315961,570918,988289,499400,323820,317965,875415,240565,551751,484005,220460,124632,41908,694575,49046,185786,973824,714358,800699,233193,595179,711345,510606,549393,973974,253222,282189,300198,853463,537264,697780,672405,576992,823907,506017,26243,841561) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 464522 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 464522 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000435s ]