SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509041 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509041 [ RunTime:0.001854s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (124000,580317,695772,589326,250444,28017,967543,673809,961537,633618,459147,529923,504308,112602,242658,296640,935154,109489,331038,775546,545143,534885,288599,717793,941068,34679,338426,531100,1043426,611561,208327,671090,807658,118081,372109,267143,317444,456909,9336,357563,460022,369527,127535,817826,443942,787831,730982,920815,5228,728557,482099,122790,760193,836571,419217,135220,484377,487784,624184,109331) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001483s ]