SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031573 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031573 [ RunTime:0.001480s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (768866,442123,64530,983774,82447,45386,851233,754044,889804,1019689,513324,1035499,593498,346346,368852,145284,784639,240721,921422,47040,723161,502010,594409,190311,233773,483645,399717,929496,121496,184745,344714,756317,894709,868134,989671,964879,76120,361689,977787,217478,293024,870160,471427,834276,524320,313758,330493,509545,830414,182672,871848,478954,995282,460738,367324,373445,550142,1000643,737121,646455) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031573 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031573 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]