SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504714 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504714 [ RunTime:0.001671s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (950569,76712,802680,176287,343338,634350,924346,90928,754900,213116,135795,691528,976527,989477,963399,581955,761236,254083,335914,897013,934327,1002407,613236,353074,549821,83330,158111,854661,1034759,517359,52540,14490,923580,163220,772455,360282,113147,824084,622139,656384,964758,86818,488697,965798,395429,949916,793572,592953,643420,752688,1003332,28208,39942,866223,388517,616232,676022,34863,839904,797843) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504714 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504714 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001224s ]