SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 436506 LIMIT 1 [ RunTime:0.000674s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 436506 [ RunTime:0.004380s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (550350,128236,151889,129505,216948,513229,649299,859383,629898,1042107,101801,937125,857364,636720,953401,340143,149977,44059,491442,968542,979732,203838,242295,82260,665587,100128,504919,43485,195174,66140,653226,672289,590249,816676,101286,112414,322904,17831,597975,51550,907230,167949,353182,688992,661836,175855,542319,967534,428212,990428,555758,12847,740550,388497,226895,942192,788029,831985,560203,944762) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003762s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 436506 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000651s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 436506 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]