SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 354731 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 354731 [ RunTime:0.002429s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (526474,568783,339973,709933,135414,60745,138321,533915,193582,1000720,687759,666572,537317,176371,252104,982098,154826,198658,222497,220398,535513,757194,456939,707810,840783,14324,516879,84676,572385,97394,1041593,288388,295141,135360,456666,401189,286606,183968,343186,511019,298650,508944,457421,908974,545599,122160,30291,1009792,93675,494907,365780,683514,636446,59120,183908,422486,687416,522905,283696,934788) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000956s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 354731 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 354731 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]