SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 366032 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 366032 [ RunTime:0.002436s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (710412,567330,203499,940207,858475,309956,313879,628938,463944,360306,89149,86418,352538,536792,220521,150720,818015,495788,395715,423260,631376,872617,973127,38239,556321,673866,197294,819982,877524,377303,142796,591936,800379,697966,302756,353072,259177,39737,352174,490442,449109,244174,237729,510105,238210,895703,160939,666777,481768,792450,408857,889502,1017619,759256,736636,682047,77334,530285,634658,486725) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 366032 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 366032 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]