SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 205178 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 205178 [ RunTime:0.001730s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (374180,68387,429635,138737,881904,20294,953868,129480,642632,44400,825821,1010391,529376,85958,360539,793455,625524,278835,265162,690453,340513,368205,921287,132456,907638,792040,214219,781553,590705,3436,933466,1040813,500052,355644,1020090,991361,710452,119901,869821,153186,159430,509164,353387,532835,880513,333678,192736,812704,911517,85366,743237,101856,191970,857005,721323,406107,261,250407,372148,344672) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 205178 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 205178 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]