SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 395445 LIMIT 1 [ RunTime:0.002972s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 395445 [ RunTime:0.005793s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (253005,70091,620992,910025,536516,659858,455171,967729,620382,964462,64347,643928,88444,1045368,210513,563902,368223,135919,896273,672403,891698,347870,472347,385414,816389,331747,99784,850627,542108,260218,467880,208197,150917,357566,1016139,642105,601761,534779,90179,128816,290308,1011216,947853,187979,127340,961090,801963,876204,546254,168224,676756,540102,1010220,130609,89931,1006740,887640,527506,116764,523869) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 395445 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 395445 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.006151s ]