SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020991 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020991 [ RunTime:0.001667s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (614249,178237,388121,113058,495103,442765,728697,1030591,587818,515099,440467,1029280,63235,685066,781962,309003,888582,900449,774337,545539,1012584,462264,883241,262319,625675,813395,691889,33044,528055,450786,231394,928371,678212,665682,955588,916250,195767,353012,682516,651618,236071,947499,80350,533919,1000331,794754,450490,590615,55495,139650,314424,524711,873231,872542,1039876,994302,398034,993850,444247,260425) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000691s ]