SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533996 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533996 [ RunTime:0.001583s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (501989,306564,715008,694081,246538,521414,97295,710548,848175,833278,135927,454319,995444,561640,820432,615436,81059,314333,362744,715690,788043,844784,265178,83284,334057,519002,122880,891398,504363,846336,309484,564425,944147,711596,36666,416878,252594,253830,739292,296498,150613,8116,390183,1024487,684609,599001,535480,403070,440376,1028625,783771,1014077,655833,73497,770785,264715,1019337,505744,536716,646449) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533996 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533996 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]