SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001493s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515958 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515958 [ RunTime:0.001533s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (417042,501940,213195,241637,206500,532758,989226,330383,552216,984734,936408,525878,809051,854131,1036322,768428,947752,151916,971200,689191,143602,486933,729627,633545,163404,544958,988139,973771,694622,904574,445323,171359,183001,460823,174795,352591,673975,728184,609275,225757,860913,732847,575550,95326,24616,1005786,740979,482737,78144,404411,501087,635607,41494,580320,647750,823448,904820,703516,72206,579034) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515958 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515958 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]