SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004119 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004119 [ RunTime:0.001696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (968454,89763,580102,449057,976391,16261,758251,639117,835364,161003,523134,323105,984057,194255,7918,224475,901585,885871,814877,114007,159306,809663,253856,436995,409660,738425,721223,278203,212054,221911,329374,814691,872235,415809,73325,368624,1018931,445093,382534,621506,485043,451340,416358,898128,828678,842965,941851,905043,880387,339349,231998,334051,838940,800248,806862,895147,1021047,555095,804689,499047) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002505s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004119 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004119 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]