SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331810 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331810 [ RunTime:0.001796s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (96125,588467,974946,913799,230688,110362,255258,385889,87452,261077,139081,853538,494748,198656,454112,942057,515568,286482,69591,8683,919685,772058,192550,1030325,233580,962596,866035,293108,292148,589185,31537,230646,196868,8312,527957,993578,885308,304392,696201,18686,201835,1037667,520026,69247,933213,1009773,315179,16331,950940,910499,42063,911258,744231,638223,227180,163173,236757,18290,837325,222452) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]