SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200083 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200083 [ RunTime:0.003005s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (582755,1042921,530900,848005,123322,864873,349492,143463,105850,628650,619039,837226,364811,877176,424297,257229,369239,212175,783592,715174,903958,588278,132949,529841,117772,731278,808270,936438,855174,769716,950134,491996,737428,652667,528639,1012577,670438,845049,136575,449160,922370,304532,697576,122301,868379,811539,1043960,253466,937480,508866,729190,442975,843199,437878,387368,332804,793367,899346,903381,484627) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]