SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418723 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418723 [ RunTime:0.001851s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (800919,373804,645306,228212,259226,826899,450855,950768,549114,999770,150539,71648,448782,508931,787250,329874,388137,549556,120391,171950,901307,690090,588880,241051,717769,200112,563368,749372,876732,379101,837491,10948,286318,607716,972713,2116,92366,251932,810548,349991,89797,1035409,561114,1048144,885167,978584,126955,524643,185579,82098,701210,380205,925334,29906,220578,204267,115646,390799,905847,886247) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418723 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418723 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]