SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001397s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 570098 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 570098 [ RunTime:0.001588s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (142421,977804,498060,214060,613363,350783,709258,883380,720391,487010,916208,861185,530499,145011,618000,728798,17966,12407,652552,473631,626890,116989,199890,851461,806416,1037190,856402,976440,72534,1029658,989377,346856,10167,471456,544501,561960,611017,486587,310803,823388,542657,355037,984918,840523,892415,124635,866931,71147,533757,453664,82363,542300,667468,845863,805127,81491,181387,124292,353177,361997) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001712s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 570098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 570098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000676s ]