SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 285341 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 285341 [ RunTime:0.001742s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (101260,232547,983978,46434,808107,69205,765308,786822,232726,32602,1035384,309115,863260,118033,187675,641710,30413,979765,1035979,936599,94571,361734,899259,911002,308523,489107,775980,726298,376252,483198,488405,537595,1046819,779739,9718,698164,463987,423393,582053,297945,438744,589143,732507,98440,237698,120724,384513,256679,895909,326300,4193,424463,561031,584315,378725,202768,488634,515432,11661,1021398) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 285341 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 285341 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]