SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499608 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499608 [ RunTime:0.002820s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (723068,998661,32695,816561,286681,543960,282879,372604,496073,1005055,159562,910188,615013,29778,428393,401854,581230,549549,363968,624508,1031553,532221,646348,857775,59539,409546,601522,559088,554599,721874,175672,685343,177133,219769,233943,303340,971839,590219,206610,652197,20559,396636,818227,229510,242953,703642,220230,284243,4792,48425,470511,320399,913014,979629,701131,859852,275942,683868,1017731,666155) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499608 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000539s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499608 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]