SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001453s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 236568 LIMIT 1 [ RunTime:0.000504s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 236568 [ RunTime:0.001706s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (204206,634181,997238,323697,841410,829144,274948,498098,481836,960673,872768,954448,291643,393218,756790,600077,947289,1008541,1007016,747644,799002,310873,17300,250139,385330,573418,326771,723620,1030451,200214,75260,152828,575291,753788,612657,194867,566890,347288,336198,674358,48304,822724,17274,691179,775470,177124,990974,36619,59712,703936,231945,265497,613754,643342,1000499,922437,334445,761512,859531,748991) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 236568 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 236568 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]