SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040048 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040048 [ RunTime:0.001574s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (381442,1025034,959871,932442,456417,92401,181926,668173,796681,279502,647071,390752,723073,195494,16983,848128,756391,920513,477927,761559,704415,16559,496261,159530,996127,323810,169737,185371,612367,375494,795172,156773,773863,379604,650380,665824,384553,431760,422762,242617,745708,570882,53008,708243,266745,509868,239580,647445,401056,42038,590570,944913,419167,451309,612192,887705,23690,936297,185932,122936) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040048 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000568s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040048 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]