SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407570 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407570 [ RunTime:0.001790s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (577905,231490,603937,432048,941478,764583,81043,217957,696421,32413,419352,883649,776018,184827,573107,663810,230737,985901,523941,638572,555636,116466,392713,732125,664808,847573,363395,282620,258960,91933,453888,562246,230160,685633,917483,659935,168535,456912,756744,790416,798389,906789,553440,959017,1026422,167446,391882,737912,572390,878310,214483,533191,444823,778549,923157,505341,504521,34515,471356,734734) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407570 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407570 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]