SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803410 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803410 [ RunTime:0.004112s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (416671,282636,471300,846576,22840,585110,380319,747353,697861,3677,724468,66037,61053,702039,1039659,384726,1011762,550699,848794,197785,848416,523443,553054,871749,244838,124798,670042,143500,693497,264362,431888,207026,426224,870644,490985,572646,489721,830619,162648,917710,353101,512396,847410,641530,634673,83731,1018536,655114,664692,908886,560507,454738,929751,636225,225395,127849,1000218,163802,452843,59106) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]