SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 100568 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 100568 [ RunTime:0.001637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (627483,253698,575130,757839,1011896,385042,201884,483778,390281,636401,916639,560788,872308,656856,147895,1040605,687419,111739,179417,195410,923351,166341,188691,829343,395859,218265,802980,870066,851950,649216,291965,360474,353185,422062,101154,148866,406895,604450,652461,16431,1040379,578668,754028,238620,845915,727334,250943,259612,770330,309092,1013954,234890,592727,764960,28520,230752,430554,543278,767793,653432) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 100568 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 100568 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]