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` = 267710 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 267710 [ RunTime:0.001684s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (568620,644957,625004,187619,882295,1032386,837930,452169,548275,1030433,505134,633693,55545,240735,423115,845498,238825,155335,109962,482342,849596,131771,227361,374721,607778,476811,900157,579521,258942,674259,779881,456692,921905,60370,451681,129100,252830,222441,742891,443316,287771,109164,132652,369026,770858,999281,415020,218604,264042,643124,408181,170293,538004,248661,413420,342394,457454,885072,418573,807288) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 267710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 267710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]