SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343528 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343528 [ RunTime:0.001641s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (399332,169190,765846,391735,204453,193448,958500,31367,990497,596851,118572,491652,463444,974024,982952,108227,236966,367448,716831,1014480,107435,316152,921201,257295,155952,444989,44861,766619,476197,80608,617673,181746,369423,382992,724758,330247,343226,607866,798149,822024,794885,854506,297416,644747,55006,930442,614656,449254,204128,826851,244170,771281,472634,353037,318058,63481,245937,723352,163757,270510) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000361s ]