SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001674s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020604 LIMIT 1 [ RunTime:0.000450s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020604 [ RunTime:0.001990s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (807766,21962,980645,1001539,203206,517306,849899,753892,466158,19797,810800,802976,236640,743821,373697,574698,394720,826550,197647,447402,450833,556062,448625,499939,562310,1031187,775381,758139,53704,605664,254968,236265,289511,113851,899380,926236,113587,37994,995080,403879,478673,99851,371627,659684,980362,224799,34212,939012,939585,401526,442811,862915,971800,103174,599441,16962,391357,105942,461766,266295) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020604 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020604 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000939s ]