SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 111883 LIMIT 1 [ RunTime:0.000488s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 111883 [ RunTime:0.007108s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (208067,172763,20666,829444,488830,239022,619843,400402,121836,702522,335833,143123,750359,511776,727418,390242,258920,1042943,455158,573228,552836,944121,626668,499375,896739,693855,82425,494420,81801,859192,338550,874113,715109,221179,94434,430656,296480,466042,377074,953323,1019224,958559,152861,980026,232008,3756,685326,233787,908274,77147,528785,74119,442026,212352,93977,474753,151168,688554,752498,169710) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 111883 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 111883 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]