SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418387 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418387 [ RunTime:0.002164s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (254815,554944,265079,314371,843274,1008924,800290,1042393,366276,951368,904695,403989,647886,286515,874055,990113,792806,510612,1028647,274340,107055,676702,737383,934447,310659,868941,295239,515095,560203,84113,288163,41977,475164,247665,365229,132230,815830,1004133,684306,701939,547184,332177,749323,340727,31184,715310,358567,533820,651673,97158,647708,489715,981314,633723,584668,850749,28440,735809,936565,497644) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001924s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418387 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418387 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000639s ]