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` = 479931 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 479931 [ RunTime:0.001450s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (405939,676958,340595,610054,549081,290388,990451,612429,808990,128097,748273,517286,555746,821423,1042080,640147,165923,19214,643448,532291,811295,845293,230776,616323,206039,88724,871073,248033,90443,887360,532341,86141,314108,90057,204006,829509,266842,471195,750864,824471,164445,2186,638187,133212,458855,906355,120391,16794,764092,980326,655606,705427,35299,314662,766710,666754,412593,14496,601398,21719) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 479931 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 479931 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]