SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201416 LIMIT 1 [ RunTime:0.000435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201416 [ RunTime:0.002355s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1032985,761158,496134,859310,779295,201695,788008,206665,528568,130443,705200,291051,178935,625901,378870,621737,765554,281350,549190,592484,776239,495269,759532,557627,341200,92180,506405,911255,146565,792326,586630,151819,1041378,1017232,540385,733789,741888,1040317,593381,175150,606828,543979,36637,870792,891665,150853,189699,926605,1032462,890021,577897,13317,898547,966899,270703,911594,901638,720697,681059,539896) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201416 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000544s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201416 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000920s ]