SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1013436 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013436 [ RunTime:0.002966s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (789009,163186,435578,928155,926109,963648,880736,676121,335707,120594,239470,428253,666828,882143,617067,224042,29442,184546,762884,87800,982464,820576,601995,613805,900491,299410,829864,143504,889925,478621,152420,942794,1036572,259316,578499,166461,320244,765638,996786,394849,774609,288584,672754,828787,847609,467791,402365,467024,951320,556134,968303,1008445,51422,859897,631958,471685,937065,699877,78999,1019524) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013436 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013436 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000425s ]