SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405047 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405047 [ RunTime:0.001863s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410889,613021,126344,494706,85963,533486,373660,1043354,523246,863203,1020745,22191,804987,788518,814241,280788,418012,520625,486262,379571,600764,1008128,577176,90455,141521,153774,287515,99540,807323,676193,695471,951518,573275,859660,452441,159511,260083,552606,1035905,42542,213772,54087,426175,720678,116315,764899,481717,704942,574646,349938,287639,582993,355500,544895,7221,310494,799971,551755,49152,814119) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405047 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405047 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]