SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001696s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522218 LIMIT 1 [ RunTime:0.001094s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522218 [ RunTime:0.004044s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (627108,108446,990080,633897,567707,416079,884158,60083,194895,148753,942442,395615,23359,442018,85154,1029904,916966,847041,61790,211367,363870,29072,1028297,112781,554727,651757,673420,305114,988442,956616,265297,253540,201915,916834,727158,468833,621909,888252,524286,726588,150795,1009408,535084,821427,962774,635937,749465,41145,959533,913598,774736,1011395,463781,203861,304209,173847,836021,494360,842287,790217) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000694s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000674s ]