SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 590416 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 590416 [ RunTime:0.001892s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (148480,40688,40580,535256,555658,140666,992991,626867,331754,511435,115009,22184,776428,264740,981170,553049,990789,283691,525947,840188,584568,58520,992348,368392,365767,723155,145664,446872,1005275,310132,9204,608974,486603,525066,678107,688352,782638,997465,319093,939229,564995,581175,730454,528902,14775,166040,509285,690019,312670,364594,481900,80053,504548,742374,912438,562287,734124,2076,1040684,336254) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000969s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 590416 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 590416 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]