SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1035142 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1035142 [ RunTime:0.002339s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (100016,201199,41807,814385,42275,425204,806,1040068,867384,527870,1005648,146956,978617,1041619,32559,703957,854452,765618,493439,550439,333934,479554,742499,639719,714716,13692,942413,430178,356012,643917,417298,444724,933150,317448,346430,145521,939955,60726,875776,1005151,732288,669989,582597,133969,622710,163556,889423,818352,412700,771078,931634,671247,157065,621857,812233,661741,636740,350853,641586,288797) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1035142 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1035142 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]