SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038499 LIMIT 1 [ RunTime:0.000594s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038499 [ RunTime:0.003444s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (304839,121967,379863,360576,27534,926137,81009,258648,998783,968559,188582,514999,794380,1024554,892910,76196,696358,58877,338079,369140,81938,672061,932004,13298,99675,97144,450269,589357,339347,964425,941204,249969,533770,73700,359342,958802,406886,81174,296889,380317,222542,529029,91309,621854,438681,63381,193971,176821,952220,796637,913716,504673,622964,444676,302686,621581,304809,624609,686510,486510) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038499 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038499 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]