SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001334s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580943 LIMIT 1 [ RunTime:0.000494s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580943 [ RunTime:0.002552s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1020276,542708,531020,756737,624551,553199,578203,24427,154488,922944,570623,603855,188172,309698,315053,546946,766856,351358,183691,100836,26778,956770,933765,871815,67597,89341,69202,135017,629131,883356,168391,99492,741794,165915,945783,836997,752003,98316,333185,596626,37704,118203,124499,562212,822578,633797,292146,493589,397786,998528,233434,658038,788579,584584,979268,1008884,624325,32810,232338,996784) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]