SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001797s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045048 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045048 [ RunTime:0.002249s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (702087,604745,1038658,663353,198141,954475,729714,20230,446214,110882,166465,927304,485430,433541,129118,517383,161291,93427,746195,787140,302799,558109,776386,895817,886880,623164,953235,980516,111625,354893,945376,324753,837775,300386,104455,280993,719055,1003537,83244,647029,832355,224530,112652,237438,937282,8273,240021,829645,183125,679075,513236,113843,608500,301881,539975,777904,966922,465668,281735,863851) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045048 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003647s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045048 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001366s ]