SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020263 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020263 [ RunTime:0.002135s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (173367,936929,360671,859914,587262,531300,187180,699598,724694,250950,782532,702800,323835,783389,755954,620665,283948,210374,919659,737551,323208,293478,499043,252736,363260,680373,978128,747662,221523,496349,789903,430298,604718,428122,889169,925993,145017,249680,614797,783303,59459,751094,58945,680710,846521,877499,270130,144604,651748,460969,853423,823048,118562,810242,60738,158445,747981,980881,978507,418511) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002175s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020263 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003895s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020263 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000385s ]