SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 326102 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 326102 [ RunTime:0.001999s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (949990,1026471,760286,169522,507227,353244,683003,657930,44304,592994,716015,846389,461599,19478,446304,344205,359836,247390,156158,615096,823753,610723,942881,731807,179723,466822,462755,878635,459935,551140,197790,627986,458930,345589,186554,311697,298724,96711,341448,398194,957935,406648,976193,124771,991036,333122,529598,468980,1030224,5599,323941,942834,1000685,475936,22810,547406,676397,458413,847148,208191) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 326102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 326102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]