SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001409s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 691040 LIMIT 1 [ RunTime:0.000612s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 691040 [ RunTime:0.003803s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (357087,405880,702209,324149,49600,162744,543446,885390,50515,544597,164027,493954,799642,538808,1008117,377790,649955,998133,868908,284925,653901,351956,124152,566323,299986,414207,100646,48188,361033,800700,75923,437142,385313,219433,872629,925818,660161,447470,207483,260131,104241,510375,570903,669186,500285,17672,383613,728860,651900,993228,769952,590184,239174,247497,592355,824447,347574,230335,294682,537244) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 691040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000539s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 691040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000441s ]