SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580351 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580351 [ RunTime:0.002803s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1027277,355252,92017,313117,16613,401664,710616,203294,367363,399161,14808,1010779,592018,62600,890809,470173,163554,556642,675007,947850,756608,603869,234467,996318,151920,994911,378306,870126,322666,899909,485550,20503,458254,909057,928805,899908,1003316,631595,466891,1007330,72708,873555,789367,145545,1038310,31654,622267,303670,378818,150784,258918,763966,896646,830193,1012095,894547,884256,779922,296971,761817) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580351 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580351 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000763s ]